<%
quer=request("quer")
id=request("id")
paths=request("path")
if quer=1 then %>
<%
connstr = "DBQ="+server.mappath("database/data.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set Conn=Server.CreateObject("ADODB.Connection")
set rs1=Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM data WHERE id = "&id&""
Conn.Open connstr
rs1.Open sql,conn,1,1
title=rs1("title")
content=rs1("content")
mail=rs1("mail")
tel=rs1("tel")
fax=rs1("fax")
names=rs1("name")
zip=rs1("zip")
lxr=rs1("lxr")
tel=rs1("tel")
address= rs1("address")
picflag=rs1("imgflag")
rs1.close
conn.close %>
<% if picflag=0 then
set MyFileObject=Server.CreateObject("Scripting.FileSystemObject")
a =server.mappath(paths)
set delfile = MyFileObject.getfile(a)
delfile.Delete
end if
%>
<%
Conn.Open connstr
conn.Execute "delete from data where data.id="&id&""
conn.close
%>
<% end if %>
天津市力神通用机械经销部
天津市力神通用机械经销部
－ 网上订购